package com.xmy.cultivate.mapper;

import com.xmy.cultivate.entity.EnrollInviteDetail;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 邀约详情 Mapper 接口
 * </p>
 *
 * @author hpiggy
 * @since 2024-08-29
 */
public interface EnrollInviteDetailMapper extends BaseMapper<EnrollInviteDetail> {

    @Select("select t1.*,t2.phone from enroll_invite_detail as t1 INNER JOIN enroll_customer as t2 on t1.customer_id =t2.id where t2.phone = #{phone} and t1.invite_date = #{schoolDate}")
    public List<EnrollInviteDetail> getEnrollInviteDetailByInvitePhone(@Param("phone") String phone,@Param("schoolDate") String schoolDate);
}
